<?php 
include_once('connection/connection.php');
include('header.php');
include('menu.php');
include('config.php');
$frm=$_SESSION['form_id'];
$id1=$_SESSION['id1'];
$dis_name=$_SESSION['dis_name'];
$qr="select * from tbl_dtls_q2_main where form_id='$frm'";
$res=mysql_query($qr);
$row=mysql_fetch_array($res);
if(isset($_POST['back']))
{ 
	header('Location: view_q2_2.php');
}	
if(isset($_POST['submit']))
{ 
	header('Location: view_q2_4.php');
}	
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="css/style_question.css" type="text/css" rel="stylesheet" />
<title>View Q2</title>
</head>
<body>
<div align="center">
<form action="" method="post">
	<table border="0" width="750" id="table1" cellspacing="0" cellpadding="0">
		<tr>
			<td height="30">
			<p align="center">
			<font face="Verdana" style="font-size: 10pt; font-weight: 700" color="#000000">
			Questionnaire No. </font><span style="font-weight: 700">
			<font face="Verdana" size="2" color="#000000">2</font></span></td>
		</tr>
		<tr>
			<td height="19">
			<p align="center">
			<font face="Arial" style="font-size: 8.5pt" color="#000000">(For 
			Hand Pump Schemes only)</font></td>
		</tr>
		<tr>
			<td height="18">
				<p align="center">
				<font style="font-size: 8.5pt" face="Arial" color="#000000">Page 3</font></p>
			</td>
		</tr>
		<tr>
			<td><span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt" color="#000000">&nbsp;&nbsp;Form Id = <?php echo $frm?>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;District Name = <?php echo $dis_name?></font></span></td>
		</tr>
		<tr><td>&nbsp;</td></tr>
		<tr>
			<td bgcolor="#EEEEEE" height="22"><font color="#000000">&nbsp;
			</font><span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt" color="#000000">
			&nbsp;&nbsp;Operational Aspects</font></span></td>
		</tr>
		<tr>
			<td height="208">
			<table border="1" width="750" id="table2" bgcolor="#FDF9EE" cellspacing="1" cellpadding="0" style="border-collapse:collapse; border-color:#99CCCC;">
				<tr>
					<td colspan="4">
					<span style="font-size: 4pt">&nbsp;</span></td>
				</tr>
				<tr>
					<td width="276" height="28">
					<font face="Verdana" style="font-size: 8.5pt" color="#000000">&nbsp; 
					Current status of schemes </font></td>
					<td colspan="3"><label id="OA_current_status"><font face="Verdana" style="font-size: 8.5pt">&nbsp;<?php echo "$row[OA_current_status]";?></font></label></td>
				</tr>
				<tr>
					<td width="276">
					  <p><font face="Verdana" style="font-size: 8.5pt" color="#000000">&nbsp; 
				      Operational Status </font>
			            <font style="font-size: 8.5pt" face="Verdana" color="#000000">&nbsp;</font><br>
				<font style="font-size: 8.5pt" face="Verdana" color="#000000">&nbsp; (Number of months remaining oper) </font></td>
					<td colspan="3"><label id="OA_operational_status"><font face="Verdana" style="font-size: 8.5pt">&nbsp;<?php echo "$row[OA_operational_status]";?></font></label></td>
				</tr>
				<tr>
					<td width="276">&nbsp;</td>
					<td colspan="3">&nbsp;	</td>
				</tr>
				
				<tr>
					<td width="276">
					  <p align="center"><span style="font-weight: bold"><font style="font-size: 8.5pt" face="Verdana" color="#000000">Annual Operation &amp; Maintenance Cost</font><br>
                          <font style="font-size: 8.5pt" face="Verdana" color="#000000">&nbsp;&nbsp;(In <img src="images/26rup1.jpg" width="10"> Lakhs)</font></span></td>
					<td width="161" align="center">
                  <div align="center"><strong><font style="font-size: 8.5pt" face="Verdana" color="#000000">FY 2009 - 10 </font></strong></div></td>
					<td width="155" align="center">
                  <div align="center"><strong><font style="font-size: 8.5pt" face="Verdana" color="#000000">FY 2008 - 09</font></strong></div></td>
					  
				    <td width="153" align="center"><div align="center"><strong><font style="font-size: 8.5pt" face="Verdana" color="#000000">FY 2007 - 08</font></strong></div></td>
				</tr>
				<tr>
					<td width="276" height="25" align="center">

					  <div align="center"><font style="font-size: 8.5pt" face="Verdana" color="#000000">
		          Man Power Cost</font></div></td>
					<td width="161" align="center"><label id="manpower_cost_09_10"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row[manpower_cost_09_10]";?></font></label></td>
					<td align="center"><label id="manpower_cost_08_09"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row[manpower_cost_08_09]";?></font></label></td>
				    <td align="center"><label id="manpower_cost_07_08"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row[manpower_cost_07_08]";?></font></label></td>
				</tr>
				<tr>
					<td width="276" height="24" align="center">
					  <div align="center"><font style="font-size: 8.5pt" face="Verdana" color="#000000">
		          Material Cost - Repairs</font></div></td>
					<td width="161" align="center"><label id="material_cost_09_10"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row[material_cost_09_10]";?></font></label></td>
					<td align="center"><label id="material_cost_08_09"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row[material_cost_08_09]";?></font></label></td>
				    <td align="center"><label id="material_cost_07_08"><font style="font-size: 8.5pt" face="Verdana"><?php echo "$row[material_cost_07_08]";?></font></label></td>
				</tr>
				<tr>
					<td width="276"><p align="center"></td>
					
				</tr>
				<tr>
					<td colspan="4">
					&nbsp;&nbsp;
					<span style="font-weight: bold"><font style="font-size: 8.5pt" face="Verdana" color="#000000">
					Preventive Maintenance Mechanisms in Place </font></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
						<label id="maintenence_machanism"><?php echo "$row[maintenence_machanism]";?></label></td>
				</tr>
				
			  </table>
		  </td>
		</tr>
		<tr>
			<td><span style="font-size: 4pt">&nbsp;</span></td>
		</tr>
		<tr>
			<td bgcolor="#EEEEEE" height="22"><font color="#000000">&nbsp;
			</font><span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt" color="#000000">
			&nbsp;&nbsp;Complaints Redressal Mechanism </font></span></td>
		</tr>
		<tr>
			<td>
			<span style="font-size: 3pt">&nbsp;</span></td>
		</tr>
		<tr>
			<td>
			<table border="1" width="750" id="table6" bgcolor="#FDF9EE" cellspacing="1" cellpadding="0" style="border-collapse:collapse; border-color:#99CCCC;">
				<tr>
					<td colspan="2">
					<span style="font-size: 4pt">&nbsp;</span></td>
				</tr>
				
				<tr>
					<td width="38%" height="28" rowspan="0">
					<font style="font-size: 8.5pt" face="Verdana" color="#000000">&nbsp;&nbsp; 
					1. Existing Reporting system </font></td>
			  	  <td width="62%" colspan="3"><label id="existing_reporting_system"><font style="font-size: 8.5pt" face="Verdana" >&nbsp;<?php echo "$row[existing_reporting_system]";?></font></label></td>
				</tr>
				<tr>
					<td width="38%" height="27">
					<font style="font-size: 8.5pt" face="Verdana" color="#000000">&nbsp;&nbsp; 
					2. Time Taken to address the complaint </font></td>
				  <td colspan="3"><label id="time_taken"><font style="font-size: 8.5pt" face="Verdana">&nbsp;<?php echo "$row[time_taken]";?></font></label></td>
				</tr>
				</table>
			</td>
		</tr>
		<tr>
			<td>&nbsp;
			</td>
		</tr>
		<tr>
			<td>
			<span style="font-size: 5pt">&nbsp;</span></td>
		</tr>
		<tr>
			<td bgcolor="#EEEEEE" height="22"><font color="#000000">&nbsp;
			<span style="font-weight: 700">
			<font face="Arial" style="font-size: 8.5pt">Constraint / Issued 
			Faced by PHED officials</font></span></font></td>
		</tr>
		<tr>
		  <td>
			<table border="1" width="750" id="table7" bgcolor="#FDF9EE" cellspacing="1" cellpadding="0" style="border-collapse:collapse; border-color:#99CCCC;">
				<tr>
					<td colspan="2">
					<span style="font-size: 4pt">&nbsp;</span></td>
				</tr>
				<td width="261" height="28">
					<font style="font-size: 8.5pt" face="Verdana" color="#000000">&nbsp; 
					Institutional</font></td>
					<td width="486"><label id="constraint_institutional"><font style="font-size: 8.5pt" face="Verdana" >&nbsp;<?php echo "$row[constraint_institutional]";?></font></label></td>
				</tr>
				
				<tr>
					<td width="261" height="26">&nbsp;
					<font style="font-size: 8.5pt" face="Verdana" color="#000000">
					Financial</font></td>
					<td width="486"><label id="constraint_financial"><font style="font-size: 8.5pt" face="Verdana" >&nbsp;<?php echo "$row[constraint_financial]";?></font></label></td>
				</tr>
				
				<tr>
					<td width="261" height="27">&nbsp;<font style="font-size: 8.5pt" face="Verdana" color="#000000"> 
					Operational </font></td>
					<td width="486"><label id="constraint_operational"><font style="font-size: 8.5pt" face="Verdana" >&nbsp;<?php echo "$row[constraint_operational]";?></font></label></td>
				</tr>
				</table>
		  </td>
		</tr>
		
		<tr>
			<td>&nbsp;</td>
		</tr>
		<tr>
			<td>&nbsp;</td>
		</tr>
		<tr>
			<td align="center">
			<input type="submit" value="Back" name="back" style="font-size: 8pt;font-family:Verdana; border-style: solid; border-width: 1px">&nbsp;&nbsp;
			<input type="submit" value="Next" name="submit" id="submit" style="font-size: 8pt; font-family: Verdana; border-style: solid; border-width: 1px">&nbsp;</td>
		</tr>
		<tr>
			<td>&nbsp;</td>
		</tr>
		</table>
		</form>
</div>

</body>

</html>